2015-11-09 - 23004 - Spec - PSA Deletion #BWMonitoring
SPECIFICATIONS
23004 - PSA Deletion
Purpose
Need to delete the PSA requests for both Master Data & Transaction Data as it is occupying more space in BPP.
Admin Info
Purpose
|
Need to delete the PSA requests for both Master data & Transactional data as it is occupying more space in BPP.
|
Requested By
|
Mark Harris
|
Spec Created By
|
Uday Kumar P
|
Spec Created Date
|
11/09/2015
|
Spec QA by
|
Uday Kumar P
|
Objects
|
Master Data & Transaction Data PSA Tables
|
Document Status
|
Complete
|
Estimates
SNo
|
Activity
|
Estimation in Hours
|
1
|
Research
|
10
|
2
|
Documentation
|
04
|
3
|
Development/ Config
|
16
|
4
|
Unit test in DEV
|
04
|
5
|
Unit test in QUA
|
06
|
|
TOTAL
|
40
|
References
Prior Tickets
None
Documents
Please find the attached document for list of Master data Datasources & Transactional data Datasources included in this Process Chain
Data Source List For PSA Deletion.xlsx
Spec Changes
SNo
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Functional Requirement
Purpose/WHY:
Need to delete the PSA requests for both Master data & Transactional data as it is occupying more space in BPP.
In Scope:
Master data & Transaction data PSA Tables(Full Load only).
Out of Scope:
Other Transnational datasources having Delta load.
Solution Summary
1. Need to create a new process chain.
2. Need to add the 'Delete PSA Request' process type in process chain for both master data & transaction data.
3. Need to include all Maser data Datasources in one Process type & other transactional datasources in other process type.
4. Need to create a new transport request & collect all the necessary objects.
5. Need to perform unit testing in BPD and after successful testing transport to BPQ.
Solution Details
1. Need to create a new process chain ZPC_PSA_DEL.
2. Need to add the 'Delete PSA Request' process type in process chain for both master data & transaction data.
3. Need to include all Maser data Datasources in one Process type & other transactional datasources in other process type.
4. Need to create new transport request & collect all the necessary objects.
5. Need to perform unit testing in BPD and after successful testing transport to BPQ.
Issues
Excluded the datasources for Master data hierarchies, as they donot have the PSA tables.